package com.java.zhuiyun.api.carousel_pc.mapper;

import com.java.zhuiyun.api.carousel_pc.entity.Carousel;
import com.java.zhuiyun.common.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @InterfaceName CarouselMapper
 * @Description TODO
 * @Author wuwan
 * @Date 2023/8/15 16:19
 **/
@Mapper
public interface CarouselPcMapper extends BaseMapper<Carousel> {
    /*
    * @Author wuwan
    * @Description todo 前台轮播图图查询
    * @Date 2023/8/21 8:56
    * @Return
    * @param null
    */
    @Select("SELECT * FROM carousel WHERE del_flag = 0 and carousel_status =0 ORDER BY sort_number ASC,update_time DESC ,create_time DESC ")
    List<Carousel> getCarousels();

}
